﻿CREATE TABLE [dbo].[Electorate] (
    [Id]            INT            IDENTITY (1, 1) NOT NULL,
    [Name]          NVARCHAR (50)  NOT NULL,
    [IsVacant]      BIT            NOT NULL,
    [VacantMessage] NVARCHAR (MAX) NULL,
    [State]         NVARCHAR (50)  NOT NULL
);

